Release 10.1A: OpenEdge Development:
Programming Interfaces

Defining a set of records to fetch

To fetch records, you must first define the set of records that you want Progress to fetch. For example, the following statement defines the set of all customer records:

FOR EACH Customer:

Progress allows you to define a set of records in a variety of ways. You define the set of records in a Record phrase. For more information on the syntax of Record phrases, see the OpenEdge Development: Progress 4GL Reference .

You can specify a Record phrase for the following Progress statements:

FIND
FOR [ EACH ]
OPEN QUERY
DO PRESELECT
REPEAT PRESELECT

The examples given below illustrate some of the flexibility that you have when defining a set of records. The Record phrases are highlighted. You can build complex Record phrases using the AND and OR operands.

This example defines a set of one record (customer 11):

FIND Customer WHERE cust-num = 11.

This example uses the word-indexed field Comments to define a set of records (all customer records containing the word “ship”):

FOR EACH Customer WHERE Comments CONTAINS "ship":

This example creates the subset of all Order records with the Customer number = 11:

OPEN QUERY ordqry FOR EACH Order WHERE Cust-Order = 11.

This example defines a set of customer records (those between 25 and 50) to be preselected:

REPEAT PRESELECT EACH Customer WHERE cust-num > 25 AND cust-num < 50: